{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Current PO Checklist","Acerno_Cache_XXXXX","PO Scoring Summary","Individual PO's Scorecard","PO Line Review","Buyer Pivot","Lookups"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":43,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Current PO Checklist","index":0,"n_rows":224,"n_cols":4,"rows_kept":224,"cut":false,"hidden":true,"merged":[]}
[null,"Purpose"]
[null,"The purpose of the PO Analysis is to determine if procurement staff are processing purchases according to the Purchasing Act (Section 50-5 of the Official Code of Georgia, Annotated [O.C.G.A.]), the Georgia Procurement Manual (GPM), and applicable best practices.   "]
[null,"The PO Analysis includes four types of reviews:"]
[null,"Purchase Type Review "]
[null,"The PO Workbook contains one tab for each purchase type.  When preparing the workbook, ensure that only purchase orders with the code reflected in the tab name are on that spreadsheet (e.g. the “OMP” tab will contain only Open Market purchase orders).  In the comment section of the purchase order workbook, document any errors revealed during the review."]
[null,"Using the corresponding checklist questions below, determine if correct purchase type codes were applied for each of the purchase orders that are sampled in the PO Workbook."]
[null,"NOTE:"]
[null,"Each purchase order sampled will be reviewed for Compliance (C) or Non-Compliance (NC).  Points are awarded for Compliance based on the questions listed and if there are no issues, a total of 20 points will be awarded per purchase order.  Points are subtracted for each question when non-compliance is found.  "]
[null,"Tier One (1)"]
[null,"A.    Statewide Contract Mandatory (SWCM) ","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·         Were the goods/services purchased available on a Mandatory Statewide Contract found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·         Was the correct contract number used?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected for “non-catalog” items?","C","NC"]
[null,"Total Points",20]
[null,"*If an incorrect NIGP code is noted on a SWCM in Window Shopper, please notify Process.Improvement@doas.ga.gov"]
[null,"Tier Two (2)"]
[null,"B.  Agency Contract (AC)  - State Entity Contract","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·         Were the goods/services purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"a.      If yes, was a Statewide Contract Waiver Request (SPD-NI005) form submitted to State Purchasing Division at: ProcessImprovement@doas.ga.gov as required?"]
[null,"b.      If yes, did State Purchasing approve the waiver request?"]
[null,"c.      If yes, was the purchase within the time period allowed on the waiver request?"]
[null,"d.      If yes, was the purchase amount within the set amount allowed on the waiver request?"]
[null,"·         Were the goods/services purchased on an existing State Entity Contract (AC)?  If no, skip to Tier Three (3)"]
[null,"a.      If yes, was the correct contract number used?"]
[null,"b.      If yes, was the contract in effect at the time of purchase?  (i.e. not expired and renewed as "]
[null,"appropriate)"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected? ","C","NC"]
[null,"Total Points",20]
[null,"Tier Three (3)"]
[null,"C.  Statutory Mandatory Sources of Supply (MAN) ","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"1.  Determine if the correct process was followed:",15]
[null,"·         Were the goods/services purchased available on an existing State Entity Contract (AC)?"]
[null,"·         Were the goods purchased listed as Mandatory (MAN) on the State Use Procurement List?  This list is located at:  http://doas.ga.gov/StateLocal/SPD/Contracts/Pages/Home.aspx."]
[null,"·         Were the goods/services purchased from the State Use Procurement List, mentioned above, shown as “Preferred” (PRF) products?"]
[null,"3. Did the purchase order description clearly identify the goods purchased?",2]
[null,"4. Is the correct NIGP Code assigned as shown in Window Shopper for the item(s)?* ","C","NC"]
[null,"Total Points",20]
[null,"*If an incorrect NIGP code is noted on a MAN item in Window Shopper, please notify Process.Improvement@doas.ga.gov"]
[null,"Tier Four (4)"]
[null,"D.  Statewide Contract Convenience (SWCC) ","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·         Were the goods/services purchased available on an existing State Entity Contract (AC)?"]
[null,"·         Were the goods/services purchased available on the Convenience Contract (SWCC)?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected for “non-catalog” items? ","C","NC"]
[null,"Total Points",20]
[null,"*If an incorrect NIGP code is noted on a SWCC in Window Shopper, please notify Process.Improvement@doas.ga.gov"]
[null,"E.  Preferred (PRF)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·         Were the goods purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"a.    If yes, was a Statewide Contract Waiver Request (SPD-NI005) form submitted to State Purchasing Division at: ProcessImprovement@doas.ga.gov as required?"]
[null,"b.    If yes, did State Purchasing approve the waiver request?"]
[null,"c.    If yes, was the purchase within the time period allowed on the waiver request?"]
[null,"d.    If yes, was the purchase amount within the set amount allowed on the waiver request?"]
[null,"·         Were the goods purchased available on an existing State Entity Contract (AC)?"]
[null,"·         Were the goods available at a preferred price by GEPS?"]
[null,"3. Does the purchase order description clearly identify the goods purchased?",2]
[null,"4. Is the NIGP Code correct as shown in Window Shopper for the item(s)?*","C","NC"]
[null,"Total Points",20]
[null,"*If an incorrect NIGP code is noted on a PRF item in Window Shopper, please notify Process.Improvement@doas.ga.gov"]
[null,"F.   State Entity Contract Piggyback (ACP)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·         Were the goods/services purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·         If yes, was a Statewide Contract Waiver Request (SPD-NI005) form submitted to State Purchasing Division at: ProcessImprovement@doas.ga.gov as required?"]
[null,"a.    If yes, did State Purchasing approve the waiver request?"]
[null,"b.    If yes, was the purchase within the time period allowed on the waiver request?"]
[null,"c.    If yes, was the purchase amount within the set amount allowed on the waiver request?"]
[null,"·         Were the goods/services purchased available on an existing State Entity Contract (AC)?"]
[null,"·         Were the goods purchased listed as Mandatory (MAN) on the State Use Procurement List?  This list is located at:  http://doas.ga.gov/StateLocal/SPD/Contracts/Pages/Home.aspx"]
[null,"·         Was SPD-NI006 (Piggyback Request) form completed and submitted by APO/CUPO for approval to the State Purchasing Division at: ProcessImprovement@doas.ga.gov?"]
[null,"a.    Was approval granted from State Purchasing to use another State Entity’s contract?"]
[null,"·         Did the PO include only goods/services included in the contract?"]
[null,"·         Did the purchase(s) stay within the approved amount per request?"]
[null,"·         Did the total spend exceed the total contracted amount?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected from the contract? ","C","NC"]
[null,"Total Points",20]
[null,"G.  State Entity Cooperative/Consortia Purchase (ACC)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2 Determine if the correct process was followed:",15]
[null,"·         Were the goods/services purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·         If yes, was a Statewide Contract Waiver Request (SPD-NI005) form submitted to State Purchasing Division at: ProcessImprovement@doas.ga.gov as required?"]
[null,"a.    If yes, did State Purchasing approve the waiver request?"]
[null,"b.    If yes, was the purchase within the time period allowed on the waiver request?"]
[null,"c.    If yes, was the purchase amount within the set amount allowed on the waiver request?"]
[null,"·         Were the goods/services purchased available on an existing State Entity Contract (AC)?"]
[null,"·         Were the goods purchased listed as Mandatory (MAN) on the State Use Procurement List?  This list is located at:  http://doas.ga.gov/StateLocal/SPD/Contracts/Pages/Home.aspx"]
[null,"·         Was a Sole Source (SS) notice posted to the GPR before the purchase was made?"]
[null,"a.    Did the Sole Source posting include:  (see reference in GPM Sections 1.3.4.4. and 2.3.2.2., Table 2.6  Conducting a Sole-Source Purchase)"]
[null,"§  Detailed description of the goods/services to be purchased?"]
[null,"§  The exact quantity?"]
[null,"§  The per unit price, and the total price (i.e. Quantity x unit price)?"]
[null,"§  If the exact quantity was not known and the state entity was establishing an open contract was the estimated quantity, the per unit price, and the total estimated value of the open contract (i.e. Estimated quantity x unit price) detailed?"]
[null,"§  The expected term of the contract, to include any renewal options?"]
[null,"§  The identity of the sole-source supplier?"]
[null,"§  The completed Sole-Source Intent to Award Justification form (SPD-PS020)?"]
[null,"§  Instructions to interested suppliers to file any challenges to the sole-source determination in accordance with SPD’s established process for resolving protests?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"H.  Open Market Purchase (OMP)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2.  Determine if the correct process was followed:",15]
[null,"·            Were the goods/services purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·            If yes, was a Statewide Contract Waiver Request (SPD-NI005) form submitted to State Purchasing Division at: ProcessImprovement@doas.ga.gov as required?"]
[null,"a.    If yes, did State Purchasing approve the waiver request?"]
[null,"b.    If yes, was the purchase within the time period allowed on the waiver request?"]
[null,"c.    If yes, was the purchase amount within the set amount allowed on the waiver request?"]
[null,"·            Were the goods/services purchased available on an existing State Entity Contract?"]
[null,"·            Were the goods purchased listed as Mandatory (MAN) on the State Use Procurement List?  This list is located at:  http://doas.ga.gov/StateLocal/SPD/Contracts/Pages/Home.aspx"]
[null,"·            If the purchase was = or >$25,000.00, was it competitively bid on the GPR?"]
[null,"a.    If yes, is the correct RFx number indicated on the PO?"]
[null,"b.    If yes, did the total spend on the purchase order exceed the total award amount?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"A.  Multiple Purchase Order Types (MUL)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·      Was the PO issued to a single supplier using a combination of purchase types (examples below): "]
[null,"a.        OMP (less than $25,000) and SWCM?"]
[null,"b.        OMP (less than $25,000) and SWCC?"]
[null,"c.        OMP (less than $25,000) and AC (less than $25,000) and MAN?"]
[null,"d.        PRF (GEPS preferred) and MAN (GEPS mandatory)?"]
[null,"e.        MAN (GCI certified) and IGA (GCI non-certified)?"]
[null,"f.         SWCC and SWCM?"]
[null,"·      If the goods/services on the purchase order were listed on a Mandatory Statewide Contract (SWCM) found in Window Shopper, and the purchase was not made against the SWCM, was a Statewide Contract Waiver Request (SPD-NI005) form submitted to State Purchasing Division at: ProcessImprovement@doas.ga.gov as required?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"a.      If yes, did State Purchasing approve the waiver request?"]
[null,"b.      If yes, was the purchase within the time period allowed on the waiver request?"]
[null,"c.      If yes, was the purchase amount within the set amount allowed on the waiver request?"]
[null,"·      Were the goods/services purchased available on a current State Entity Contract (AC)?"]
[null,"·      Were the goods/services purchased on the State Use Procurement List located at:  http://doas.ga.gov/StateLocal/SPD/Contracts/Pages/Home.aspx ?"]
[null,"·      Were the goods/services purchased available on a current Convenience Statewide Contract (SWCC) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·      If Open Market purchases were combined with Statewide/State Entity Contract purchases, did the OMP purchase order lines total or exceed $25,000?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"*If an incorrect NIGP code is noted on a SWCM, SWCC, MAN, or PRF item in Window Shopper, please notify Process.Improvement@doas.ga.gov"]
[null,"B.  Exempt (EXM)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·            Was the purchase exempt per the GPM, Section 1.2.or per the NIGP Exempt List?  (Exempt list is located at:  http://doas.ga.gov/StateLocal/SPD/Docs_SPD_General/NIGPExemptList.pdf"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"C.  Intergovernmental (IGA)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·            Was/were the goods/services available for purchase from a governmental source (e.g. State Entity, State Authority, City, County, School, BOR, etc.)?  "]
[null,"D.  Intergovernmental (IGA)","C","NC"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"E.  Emergency (EMER)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·      Was the purchase a true emergency purchase?  (Urgently needed goods/services arising from unforeseen causes, including, but not limited to, extreme weather conditions or official declared emergencies, O.C.G.A. Section 50-5-71)"]
[null,"·      Was the Emergency Justification form (SPD-NI004) completed and attached to the PO (TGM users) or submitted to the State Purchasing Division (process.improvement@doas.ga.gov) within five (5) business days of the purchase (Non TGM users)?"]
[null,"·      For non-TGM users, did the Entity submit supporting purchase documentation (Purchase Order or P-Card receipt) to the State Purchasing Division (process.improvement@doas.ga.gov) once the purchase of goods/services was completed?  "]
[null,"·      Was the reason noted on the justification resulting from poor planning?"]
[null,"·      Was an expiration date or term limit assigned by the State Entity on the Emergency documentation?   "]
[null,"a.    If yes, was it reasonable or should it have been bid?"]
[null,"·      For non-TGM users, was SPD notified of any change orders applied to the purchase documentation?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"F.   Sole Source (SS)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·      Were the goods/services purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·      If yes, was a Statewide Contract Waiver Request (SPD-NI005) form submitted to State Purchasing Division at: ProcessImprovement@doas.ga.gov as required?"]
[null,"a.    If yes, did State Purchasing approve the waiver request?"]
[null,"b.    If yes, was the purchase within the time period allowed on the waiver request?"]
[null,"c.    If yes, was the purchase amount within the set amount allowed on the waiver request?"]
[null,"·      Were the goods/services purchased available on an existing State Entity Contract (AC)?"]
[null,"·      Were the goods purchased listed as Mandatory (MAN) on the State Use Procurement List?  This list is located at:  http://doas.ga.gov/StateLocal/SPD/Contracts/Pages/Home.aspx"]
[null,"·      Was there evidence of thorough market research to include documentation of appropriate justification?  (Sole Source procurement is to be used as a last justifiable option and not as an attempt to contract with a favored Supplier.)"]
[null,"·      Was the Sole Source (SS) notice posted on the GPR before the purchase was made?"]
[null,"·      Was the completed Sole-Source Intent to Award Justification form (SPD-PS020) posted with the Sole Source notice?"]
[null,"·      Did the Sole Source notice justification include the following information:  (see GPM Sections 1.3.4.4. and 2.3.2.2., Table 2.6  Conducting a Sole-Source Purchase)"]
[null,"a.    Detailed description of the goods/services to be purchased?"]
[null,"b.    The exact quantity?"]
[null,"c.    The per unit price, and the total price (i.e. Quantity x unit price)?"]
[null,"d.    If the exact quantity is not known because the state entity seeks to establish an open contract without seeking bids/proposals (e.g. Using sources of supply established by other states, consortia, or cooperatives), was the estimated quantity, the per unit price, and the total estimated value of the open contract (i.e. Estimated quantity x unit price) included?"]
[null,"e.    The expected term of the contract, to include any renewal options?"]
[null,"f.     The identity of the sole-source supplier?"]
[null,"·      Were instructions to interested suppliers on how to file any challenges to the sole-source included in the posting to the GPR?  (GPM Section 2.3.2.2., Table 2.6, and Table 2.7)"]
[null,"·      Was the Sole-Source Notice posted to the GPR for the correct posting time as listed in the GPM (GPM section 2.3.2.2. and Table 2.6)?"]
[null,"·      If an NIGP review is not currently being performed, was/were the correct NIGP Code(s) chosen from the contract? (5 digit, not ending in “00”)"]
[null,"·      Was the purchase order executed within the period identified on the contract, if applicable?"]
[null,"·      Did the purchase order exceed contract amount or contract term?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"G.  Sole Brand (SB)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·         Were the goods/services purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·         Was the purchase order totaling $25,000 or above competitively bid?"]
[null,"a.    If yes, was a completed and signed Sole Brand justification form (SPD-PS019) posted to GPR?"]
[null,"·         Were purchases executed within the period identified in the contract?"]
[null,"·         Did the purchase order exceed contract amount or contract term?"]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]
[null,"NOTE:  If Construction is exempt for your state entity, disregard this section in your review."]
[null,"H.  Construction Contracts (CSN)","C","NC"]
[null,"1. Is the PO coded correctly?",3]
[null,"2. Determine if the correct process was followed:",15]
[null,"·      Were the goods/services purchased available on a Mandatory Statewide Contract (SWCM) found in Window Shopper?  (Window Shopper can be accessed at: http://doas.ga.gov/TGM/Pages/WindowShopper.aspx to verify.)"]
[null,"·       "]
[null,"3. Did the purchase order description clearly identify the goods/services purchased?",2]
[null,"4. Is the correct NIGP Code selected?","C","NC"]
[null,"Total Points",20]

{"sheet":"Acerno_Cache_XXXXX","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"PO Scoring Summary","index":2,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,4,23,4],[0,0,0,8],[24,5,24,9],[25,5,33,9],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[22,7,22,8],[19,0,19,3],[5,0,5,1],[9,0,10,0],[21,7,21,8],[16,5,16,9],[17,5,17,6],[2,1,2,2],[18,7,18,8],[20,7,20,8],[19,7,19,8],[13,3,14,3],[17,7,17,8]]}
["<Select Entity Name from List>"]
[]
["Completed by:"]
["Date:"]
[]
["Scoring Summary",null,null,"Criteria","PO Type","Order of Precedence","Clear Description","Correct 3-Digit NIGP","Other Specific Procedures"]
["Max Pts Available",{"$f":"IF(SUM(max_score)=0,\"\",SUM(max_score))","v":""},null,"Criteria Points",3,4,3,3,3]
["Points Earned",{"$f":"IF(SUM(po_rating)=0,\"\",SUM(po_rating))","v":""},null,"# of Compliant",{"$f":"COUNTIF(type,\"Yes\")","v":0},{"$f":"COUNTIF(source,\"Yes\")","v":0},{"$f":"COUNTIF(clear_desc,\"Yes\")","v":0},{"$f":"COUNTIF(nigp,\"Yes\")","v":0},{"$f":"COUNTIF(specific,\"Yes\")","v":0}]
[null,null,null,"# of Non-compliant",{"$f":"COUNTIF(type,\"No\")","v":0},{"$f":"COUNTIF(source,\"No\")","v":0},{"$f":"IF(SUM(po_rating)=0,\"\",COUNTIF(description,\"No\"))","v":""},{"$f":"IF(SUM(po_rating)=0,\"\",COUNTIF(nigp,\"No\"))","v":""},{"$f":"COUNTIF(specific,\"No\")","v":0}]
["Compliance Rating / Tier",{"$f":"IF(ISBLANK(B3)=TRUE,\"Enter Completed By Above\",IF(ISERROR(ROUND((SUM(po_rating)/SUM(max_score)),2))=TRUE,\"No Data\",ROUND((SUM(po_rating)/SUM(max_score)),2)))","v":"Enter Completed By Above"},null,"# of Other/Needs Improve.",{"$f":"COUNTIF(type,\"Needs Improvement\")","v":0},{"$f":"COUNTIF(source,\"Needs Improvement\")","v":0},{"$f":"IF(SUM(po_rating)=0,\"\",C18-G8-G9)","v":""},{"$f":"COUNTIF(nigp,\"Needs Improvement\")","v":0},{"$f":"COUNTIF(specific,\"Needs Improvement\")","v":0}]
[null,{"$f":"IF(ISBLANK(B3)=TRUE,\"Enter Completed By Above\",IF(B10<=G23,J23,IF(B10<=G22,J22,IF(B10<=G21,J21,IF(B10<=G20,J20,J19)))))","v":"Enter Completed By Above"},null,"Points Earned",{"$f":"SUM(score_po_type)","v":0},{"$f":"SUM(score_op)","v":0},{"$f":"IF(SUM(po_rating)=0,\"\",SUM(score_desc))","v":""},{"$f":"SUM(score_nigp)","v":0},{"$f":"SUM(score_proc)","v":0}]
[null,null,null,"Possible Points",{"$f":"B18*E7","v":0},{"$f":"B18*F7","v":0},{"$f":"B18*G7","v":0},{"$f":"B18*H7","v":0},{"$f":"B18*I7","v":0}]
[null,null,null,"Score for Area",{"$f":"IF(SUM(po_rating)=0,\"\",IF(ISERROR(E11/E12)=TRUE,\"No Data\",E11/E12))","v":""},{"$f":"IF(SUM(po_rating)=0,\"\",IF(ISERROR(F11/F12)=TRUE,\"No Data\",F11/F12))","v":""},{"$f":"IF(SUM(po_rating)=0,\"\", IF(ISERROR(G11/G12)=TRUE,\"No Data\",G11/G12))","v":""},{"$f":"IF(SUM(po_rating)=0,\"\",IF(ISERROR(H11/H12)=TRUE,\"No Data\",H11/H12))","v":""},{"$f":"IF(SUM(po_rating)=0,\"\",IF(ISERROR(I11/I12)=TRUE,\"No Data\",I11/I12))","v":""}]
[null,null,null,"Type of Write-up",{"$f":"IF(E13=\"No Data\",\"No Data\",IF(E13<0.8,\"Issue\",IF(AND(E13<0.95,E13>=0.8),\"Issue\",IF(E13<1,\"Other Recommendation\",\"No Comments\"))))","v":"No Comments"},{"$f":"IF(F13=\"No Data\",\"No Data\",IF(F13<0.8,\"Issue\",IF(AND(F13<0.95,F13>=0.8),\"Issue\",IF(F13<1,\"Other Recommendation\",\"No Comments\"))))","v":"No Comments"},"No Comments","No Comments","No Comments"]
[]
["Total Spend","Enter Total Spend from 19D Here"]
["Total Spend Reviewed",{"$f":"SUM(amount)","v":0},{"$f":"IF(ISERROR(B17/B16)=TRUE,\"\",B17/B16)","v":""},null,null,"PO Rating Scales"]
["# of PO's / Lines Reviewed",{"$f":"COUNTIF(po_num,\"*\")-1","v":0},{"$f":"COUNTIF(line_review_PO,\"*\")-1","v":0},null,null,"Compliance Ranges",null,"Grade",null,"Tier"]
[null,null,null,null,null,0.95,1,"Excellent",null,"Tier I (+)"]
["Buyer Performance Summary",null,null,null,null,0.85,0.94,"Acceptable",null,"Tier I"]
["Buyers","Total PO's Reviewed","Buyer Average","Max Score for Entity",null,0.75,0.84,"Marginal",null,"Tier II"]
[null,{"$f":"COUNTIFS(buyer,A22,blanks,\"=0\")","v":0},{"$f":"IF(ISERROR(AVERAGEIFS(po_rating,buyer,A22)=TRUE),\"\",ROUNDUP(AVERAGEIFS(po_rating,buyer,A22),2))","v":""},{"$f":"IF(A22=\"\",\"\",IF(ISERROR(ROUNDUP(AVERAGE(max_score),2))=TRUE,\"\",ROUNDUP(AVERAGE(max_score),2)))","v":""},{"$f":"IF(ISBLANK(A22)=TRUE,\"Copy formulas in B21:D21 to all rows.\",\"\")","v":"Copy formulas in B21:D21 to all rows."},0.6,0.74,"Significant Non-Compliance",null,"Tier III"]
[null,0,"","",null,null,0.59,"Unsatisfactory",null,"Tier IV"]
[null,0,"",""]
[null,0,"","",null,"Rating / Tier Definition"]
[null,0,"","",null,{"$f":"IF(ISBLANK(B3)=TRUE,\"Must Enter Completed By in Cell B3\",VLOOKUP(B11,ratings,3,FALSE))","v":"Must Enter Completed By in Cell B3"}]
[null,0,"",""]
[null,0,"",""]
[null,0,"",""]
[null,0,"",""]
[null,0,"",""]
[null,0,"",""]
[null,0,"",""]

{"sheet":"Individual PO's Scorecard","index":3,"n_rows":479,"n_cols":27,"rows_kept":479,"cut":false,"hidden":false,"merged":[]}
["Entity_Name","PO_Num","PO_Date","PO_Type","Vendor_Name","Buyer","Origin","PO_Amt","PO_Line_Count (do not copy over this column)","Comments_/_Questions_for_Entity_Response","Correct_PO_Type?","Order_of_Precedence?","Other_Specific_Procedures?","Clear_Description?","Clear_Desc_Count","Desc_NI","Correct_3-Digit_NIGP?","Correct_3__Count","NIGP_3_NI","Individual_PO_Rating","Max_Score_for_PO","PO_Type","OP","Desc","NIGP","Proc.","Blanks"]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B2)=0,\"\",COUNTIF(line_review_PO,B2))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B2)=TRUE,\"\",IF(AND(I2=O2,P2=0),\"Yes\",IF(AND(O2=0,P2>0),\"No\",\"Needs Improvement\")))","v":""},{"$f":"COUNTIFS(line_review_PO,B2,clear_desc,\"=Yes\")","v":0},{"$f":"COUNTIFS(line_review_PO,B2,clear_desc,\"<>Yes\")","v":0},{"$f":"IF(ISBLANK(B2)=TRUE,\"\",IF(AND(I2=R2,S2=0),\"Yes\",IF(R2=0,\"No\",\"Needs Improvement\")))","v":""},{"$f":"COUNTIFS(line_review_PO,B2,correct_3,\"Yes\")","v":0},{"$f":"COUNTIFS(line_review_PO,B2,correct_3,\"Needs Improvement\")","v":0},{"$f":"IF(ISBLANK(B2)=TRUE,\"\",IF(AA2>0,\"\",SUM(V2:Z2)))","v":""},{"$f":"IF(ISBLANK(B2)=TRUE,\"No PO\",IF(M2<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K2=\"Yes\",'PO Scoring Summary'!$E$7,IF(K2=\"No\",0,\"\"))","v":""},{"$f":"IF(L2=\"Yes\",'PO Scoring Summary'!$F$7,IF(L2=\"No\",0,\"\"))","v":""},{"$f":"IF(N2=\"\",\"\",IF(N2=\"Yes\",'PO Scoring Summary'!$G$7,IF(P2=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q2=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M2=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M2=\"No\",M2=\"N/A\"),0,IF(ISBLANK(M2)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},{"$f":"COUNTIF(K2:M2,\"\")","v":3}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B3)=TRUE,\"No PO\",IF(M3<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K3=\"Yes\",'PO Scoring Summary'!$E$7,IF(K3=\"No\",0,\"\"))","v":""},{"$f":"IF(L3=\"Yes\",'PO Scoring Summary'!$F$7,IF(L3=\"No\",0,\"\"))","v":""},{"$f":"IF(N3=\"\",\"\",IF(N3=\"Yes\",'PO Scoring Summary'!$G$7,IF(P3=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q3=\"\",\"\",IF(Q3=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q3=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M3=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M3=\"No\",M3=\"N/A\"),0,IF(ISBLANK(M3)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B4)=TRUE,\"No PO\",IF(M4<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K4=\"Yes\",'PO Scoring Summary'!$E$7,IF(K4=\"No\",0,\"\"))","v":""},{"$f":"IF(L4=\"Yes\",'PO Scoring Summary'!$F$7,IF(L4=\"No\",0,\"\"))","v":""},{"$f":"IF(N4=\"\",\"\",IF(N4=\"Yes\",'PO Scoring Summary'!$G$7,IF(P4=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q4=\"\",\"\",IF(Q4=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q4=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M4=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M4=\"No\",M4=\"N/A\"),0,IF(ISBLANK(M4)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B5)=TRUE,\"No PO\",IF(M5<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K5=\"Yes\",'PO Scoring Summary'!$E$7,IF(K5=\"No\",0,\"\"))","v":""},{"$f":"IF(L5=\"Yes\",'PO Scoring Summary'!$F$7,IF(L5=\"No\",0,\"\"))","v":""},{"$f":"IF(N5=\"\",\"\",IF(N5=\"Yes\",'PO Scoring Summary'!$G$7,IF(P5=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q5=\"\",\"\",IF(Q5=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q5=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M5=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M5=\"No\",M5=\"N/A\"),0,IF(ISBLANK(M5)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B6)=TRUE,\"No PO\",IF(M6<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K6=\"Yes\",'PO Scoring Summary'!$E$7,IF(K6=\"No\",0,\"\"))","v":""},{"$f":"IF(L6=\"Yes\",'PO Scoring Summary'!$F$7,IF(L6=\"No\",0,\"\"))","v":""},{"$f":"IF(N6=\"\",\"\",IF(N6=\"Yes\",'PO Scoring Summary'!$G$7,IF(P6=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q6=\"\",\"\",IF(Q6=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q6=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M6=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M6=\"No\",M6=\"N/A\"),0,IF(ISBLANK(M6)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B7)=TRUE,\"No PO\",IF(M7<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K7=\"Yes\",'PO Scoring Summary'!$E$7,IF(K7=\"No\",0,\"\"))","v":""},{"$f":"IF(L7=\"Yes\",'PO Scoring Summary'!$F$7,IF(L7=\"No\",0,\"\"))","v":""},{"$f":"IF(N7=\"\",\"\",IF(N7=\"Yes\",'PO Scoring Summary'!$G$7,IF(P7=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q7=\"\",\"\",IF(Q7=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q7=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M7=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M7=\"No\",M7=\"N/A\"),0,IF(ISBLANK(M7)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B8)=TRUE,\"No PO\",IF(M8<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K8=\"Yes\",'PO Scoring Summary'!$E$7,IF(K8=\"No\",0,\"\"))","v":""},{"$f":"IF(L8=\"Yes\",'PO Scoring Summary'!$F$7,IF(L8=\"No\",0,\"\"))","v":""},{"$f":"IF(N8=\"\",\"\",IF(N8=\"Yes\",'PO Scoring Summary'!$G$7,IF(P8=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q8=\"\",\"\",IF(Q8=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q8=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M8=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M8=\"No\",M8=\"N/A\"),0,IF(ISBLANK(M8)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B9)=TRUE,\"No PO\",IF(M9<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K9=\"Yes\",'PO Scoring Summary'!$E$7,IF(K9=\"No\",0,\"\"))","v":""},{"$f":"IF(L9=\"Yes\",'PO Scoring Summary'!$F$7,IF(L9=\"No\",0,\"\"))","v":""},{"$f":"IF(N9=\"\",\"\",IF(N9=\"Yes\",'PO Scoring Summary'!$G$7,IF(P9=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q9=\"\",\"\",IF(Q9=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q9=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M9=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M9=\"No\",M9=\"N/A\"),0,IF(ISBLANK(M9)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B10)=TRUE,\"No PO\",IF(M10<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K10=\"Yes\",'PO Scoring Summary'!$E$7,IF(K10=\"No\",0,\"\"))","v":""},{"$f":"IF(L10=\"Yes\",'PO Scoring Summary'!$F$7,IF(L10=\"No\",0,\"\"))","v":""},{"$f":"IF(N10=\"\",\"\",IF(N10=\"Yes\",'PO Scoring Summary'!$G$7,IF(P10=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q10=\"\",\"\",IF(Q10=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q10=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M10=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M10=\"No\",M10=\"N/A\"),0,IF(ISBLANK(M10)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B11)=TRUE,\"No PO\",IF(M11<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K11=\"Yes\",'PO Scoring Summary'!$E$7,IF(K11=\"No\",0,\"\"))","v":""},{"$f":"IF(L11=\"Yes\",'PO Scoring Summary'!$F$7,IF(L11=\"No\",0,\"\"))","v":""},{"$f":"IF(N11=\"\",\"\",IF(N11=\"Yes\",'PO Scoring Summary'!$G$7,IF(P11=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q11=\"\",\"\",IF(Q11=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q11=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M11=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M11=\"No\",M11=\"N/A\"),0,IF(ISBLANK(M11)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B12)=TRUE,\"No PO\",IF(M12<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K12=\"Yes\",'PO Scoring Summary'!$E$7,IF(K12=\"No\",0,\"\"))","v":""},{"$f":"IF(L12=\"Yes\",'PO Scoring Summary'!$F$7,IF(L12=\"No\",0,\"\"))","v":""},{"$f":"IF(N12=\"\",\"\",IF(N12=\"Yes\",'PO Scoring Summary'!$G$7,IF(P12=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q12=\"\",\"\",IF(Q12=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q12=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M12=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M12=\"No\",M12=\"N/A\"),0,IF(ISBLANK(M12)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B13)=TRUE,\"No PO\",IF(M13<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K13=\"Yes\",'PO Scoring Summary'!$E$7,IF(K13=\"No\",0,\"\"))","v":""},{"$f":"IF(L13=\"Yes\",'PO Scoring Summary'!$F$7,IF(L13=\"No\",0,\"\"))","v":""},{"$f":"IF(N13=\"\",\"\",IF(N13=\"Yes\",'PO Scoring Summary'!$G$7,IF(P13=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q13=\"\",\"\",IF(Q13=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q13=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M13=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M13=\"No\",M13=\"N/A\"),0,IF(ISBLANK(M13)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B14)=TRUE,\"No PO\",IF(M14<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K14=\"Yes\",'PO Scoring Summary'!$E$7,IF(K14=\"No\",0,\"\"))","v":""},{"$f":"IF(L14=\"Yes\",'PO Scoring Summary'!$F$7,IF(L14=\"No\",0,\"\"))","v":""},{"$f":"IF(N14=\"\",\"\",IF(N14=\"Yes\",'PO Scoring Summary'!$G$7,IF(P14=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q14=\"\",\"\",IF(Q14=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q14=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M14=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M14=\"No\",M14=\"N/A\"),0,IF(ISBLANK(M14)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B15)=TRUE,\"No PO\",IF(M15<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K15=\"Yes\",'PO Scoring Summary'!$E$7,IF(K15=\"No\",0,\"\"))","v":""},{"$f":"IF(L15=\"Yes\",'PO Scoring Summary'!$F$7,IF(L15=\"No\",0,\"\"))","v":""},{"$f":"IF(N15=\"\",\"\",IF(N15=\"Yes\",'PO Scoring Summary'!$G$7,IF(P15=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q15=\"\",\"\",IF(Q15=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q15=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M15=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M15=\"No\",M15=\"N/A\"),0,IF(ISBLANK(M15)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B16)=TRUE,\"No PO\",IF(M16<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K16=\"Yes\",'PO Scoring Summary'!$E$7,IF(K16=\"No\",0,\"\"))","v":""},{"$f":"IF(L16=\"Yes\",'PO Scoring Summary'!$F$7,IF(L16=\"No\",0,\"\"))","v":""},{"$f":"IF(N16=\"\",\"\",IF(N16=\"Yes\",'PO Scoring Summary'!$G$7,IF(P16=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q16=\"\",\"\",IF(Q16=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q16=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M16=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M16=\"No\",M16=\"N/A\"),0,IF(ISBLANK(M16)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B17)=TRUE,\"No PO\",IF(M17<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K17=\"Yes\",'PO Scoring Summary'!$E$7,IF(K17=\"No\",0,\"\"))","v":""},{"$f":"IF(L17=\"Yes\",'PO Scoring Summary'!$F$7,IF(L17=\"No\",0,\"\"))","v":""},{"$f":"IF(N17=\"\",\"\",IF(N17=\"Yes\",'PO Scoring Summary'!$G$7,IF(P17=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q17=\"\",\"\",IF(Q17=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q17=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M17=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M17=\"No\",M17=\"N/A\"),0,IF(ISBLANK(M17)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B18)=TRUE,\"No PO\",IF(M18<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K18=\"Yes\",'PO Scoring Summary'!$E$7,IF(K18=\"No\",0,\"\"))","v":""},{"$f":"IF(L18=\"Yes\",'PO Scoring Summary'!$F$7,IF(L18=\"No\",0,\"\"))","v":""},{"$f":"IF(N18=\"\",\"\",IF(N18=\"Yes\",'PO Scoring Summary'!$G$7,IF(P18=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q18=\"\",\"\",IF(Q18=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q18=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M18=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M18=\"No\",M18=\"N/A\"),0,IF(ISBLANK(M18)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B19)=TRUE,\"No PO\",IF(M19<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K19=\"Yes\",'PO Scoring Summary'!$E$7,IF(K19=\"No\",0,\"\"))","v":""},{"$f":"IF(L19=\"Yes\",'PO Scoring Summary'!$F$7,IF(L19=\"No\",0,\"\"))","v":""},{"$f":"IF(N19=\"\",\"\",IF(N19=\"Yes\",'PO Scoring Summary'!$G$7,IF(P19=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q19=\"\",\"\",IF(Q19=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q19=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M19=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M19=\"No\",M19=\"N/A\"),0,IF(ISBLANK(M19)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B20)=TRUE,\"No PO\",IF(M20<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K20=\"Yes\",'PO Scoring Summary'!$E$7,IF(K20=\"No\",0,\"\"))","v":""},{"$f":"IF(L20=\"Yes\",'PO Scoring Summary'!$F$7,IF(L20=\"No\",0,\"\"))","v":""},{"$f":"IF(N20=\"\",\"\",IF(N20=\"Yes\",'PO Scoring Summary'!$G$7,IF(P20=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q20=\"\",\"\",IF(Q20=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q20=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M20=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M20=\"No\",M20=\"N/A\"),0,IF(ISBLANK(M20)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B21)=TRUE,\"No PO\",IF(M21<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K21=\"Yes\",'PO Scoring Summary'!$E$7,IF(K21=\"No\",0,\"\"))","v":""},{"$f":"IF(L21=\"Yes\",'PO Scoring Summary'!$F$7,IF(L21=\"No\",0,\"\"))","v":""},{"$f":"IF(N21=\"\",\"\",IF(N21=\"Yes\",'PO Scoring Summary'!$G$7,IF(P21=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q21=\"\",\"\",IF(Q21=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q21=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M21=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M21=\"No\",M21=\"N/A\"),0,IF(ISBLANK(M21)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B22)=TRUE,\"No PO\",IF(M22<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K22=\"Yes\",'PO Scoring Summary'!$E$7,IF(K22=\"No\",0,\"\"))","v":""},{"$f":"IF(L22=\"Yes\",'PO Scoring Summary'!$F$7,IF(L22=\"No\",0,\"\"))","v":""},{"$f":"IF(N22=\"\",\"\",IF(N22=\"Yes\",'PO Scoring Summary'!$G$7,IF(P22=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q22=\"\",\"\",IF(Q22=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q22=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M22=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M22=\"No\",M22=\"N/A\"),0,IF(ISBLANK(M22)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B23)=TRUE,\"No PO\",IF(M23<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K23=\"Yes\",'PO Scoring Summary'!$E$7,IF(K23=\"No\",0,\"\"))","v":""},{"$f":"IF(L23=\"Yes\",'PO Scoring Summary'!$F$7,IF(L23=\"No\",0,\"\"))","v":""},{"$f":"IF(N23=\"\",\"\",IF(N23=\"Yes\",'PO Scoring Summary'!$G$7,IF(P23=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q23=\"\",\"\",IF(Q23=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q23=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M23=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M23=\"No\",M23=\"N/A\"),0,IF(ISBLANK(M23)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B24)=TRUE,\"No PO\",IF(M24<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K24=\"Yes\",'PO Scoring Summary'!$E$7,IF(K24=\"No\",0,\"\"))","v":""},{"$f":"IF(L24=\"Yes\",'PO Scoring Summary'!$F$7,IF(L24=\"No\",0,\"\"))","v":""},{"$f":"IF(N24=\"\",\"\",IF(N24=\"Yes\",'PO Scoring Summary'!$G$7,IF(P24=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q24=\"\",\"\",IF(Q24=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q24=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M24=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M24=\"No\",M24=\"N/A\"),0,IF(ISBLANK(M24)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B25)=TRUE,\"No PO\",IF(M25<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K25=\"Yes\",'PO Scoring Summary'!$E$7,IF(K25=\"No\",0,\"\"))","v":""},{"$f":"IF(L25=\"Yes\",'PO Scoring Summary'!$F$7,IF(L25=\"No\",0,\"\"))","v":""},{"$f":"IF(N25=\"\",\"\",IF(N25=\"Yes\",'PO Scoring Summary'!$G$7,IF(P25=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q25=\"\",\"\",IF(Q25=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q25=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M25=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M25=\"No\",M25=\"N/A\"),0,IF(ISBLANK(M25)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B26)=TRUE,\"No PO\",IF(M26<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K26=\"Yes\",'PO Scoring Summary'!$E$7,IF(K26=\"No\",0,\"\"))","v":""},{"$f":"IF(L26=\"Yes\",'PO Scoring Summary'!$F$7,IF(L26=\"No\",0,\"\"))","v":""},{"$f":"IF(N26=\"\",\"\",IF(N26=\"Yes\",'PO Scoring Summary'!$G$7,IF(P26=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q26=\"\",\"\",IF(Q26=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q26=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M26=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M26=\"No\",M26=\"N/A\"),0,IF(ISBLANK(M26)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B27)=TRUE,\"No PO\",IF(M27<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K27=\"Yes\",'PO Scoring Summary'!$E$7,IF(K27=\"No\",0,\"\"))","v":""},{"$f":"IF(L27=\"Yes\",'PO Scoring Summary'!$F$7,IF(L27=\"No\",0,\"\"))","v":""},{"$f":"IF(N27=\"\",\"\",IF(N27=\"Yes\",'PO Scoring Summary'!$G$7,IF(P27=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q27=\"\",\"\",IF(Q27=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q27=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M27=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M27=\"No\",M27=\"N/A\"),0,IF(ISBLANK(M27)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B28)=TRUE,\"No PO\",IF(M28<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K28=\"Yes\",'PO Scoring Summary'!$E$7,IF(K28=\"No\",0,\"\"))","v":""},{"$f":"IF(L28=\"Yes\",'PO Scoring Summary'!$F$7,IF(L28=\"No\",0,\"\"))","v":""},{"$f":"IF(N28=\"\",\"\",IF(N28=\"Yes\",'PO Scoring Summary'!$G$7,IF(P28=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q28=\"\",\"\",IF(Q28=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q28=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M28=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M28=\"No\",M28=\"N/A\"),0,IF(ISBLANK(M28)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B29)=TRUE,\"No PO\",IF(M29<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K29=\"Yes\",'PO Scoring Summary'!$E$7,IF(K29=\"No\",0,\"\"))","v":""},{"$f":"IF(L29=\"Yes\",'PO Scoring Summary'!$F$7,IF(L29=\"No\",0,\"\"))","v":""},{"$f":"IF(N29=\"\",\"\",IF(N29=\"Yes\",'PO Scoring Summary'!$G$7,IF(P29=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q29=\"\",\"\",IF(Q29=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q29=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M29=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M29=\"No\",M29=\"N/A\"),0,IF(ISBLANK(M29)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B30)=TRUE,\"No PO\",IF(M30<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K30=\"Yes\",'PO Scoring Summary'!$E$7,IF(K30=\"No\",0,\"\"))","v":""},{"$f":"IF(L30=\"Yes\",'PO Scoring Summary'!$F$7,IF(L30=\"No\",0,\"\"))","v":""},{"$f":"IF(N30=\"\",\"\",IF(N30=\"Yes\",'PO Scoring Summary'!$G$7,IF(P30=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q30=\"\",\"\",IF(Q30=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q30=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M30=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M30=\"No\",M30=\"N/A\"),0,IF(ISBLANK(M30)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B31)=TRUE,\"No PO\",IF(M31<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K31=\"Yes\",'PO Scoring Summary'!$E$7,IF(K31=\"No\",0,\"\"))","v":""},{"$f":"IF(L31=\"Yes\",'PO Scoring Summary'!$F$7,IF(L31=\"No\",0,\"\"))","v":""},{"$f":"IF(N31=\"\",\"\",IF(N31=\"Yes\",'PO Scoring Summary'!$G$7,IF(P31=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q31=\"\",\"\",IF(Q31=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q31=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M31=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M31=\"No\",M31=\"N/A\"),0,IF(ISBLANK(M31)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B32)=TRUE,\"No PO\",IF(M32<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K32=\"Yes\",'PO Scoring Summary'!$E$7,IF(K32=\"No\",0,\"\"))","v":""},{"$f":"IF(L32=\"Yes\",'PO Scoring Summary'!$F$7,IF(L32=\"No\",0,\"\"))","v":""},{"$f":"IF(N32=\"\",\"\",IF(N32=\"Yes\",'PO Scoring Summary'!$G$7,IF(P32=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q32=\"\",\"\",IF(Q32=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q32=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M32=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M32=\"No\",M32=\"N/A\"),0,IF(ISBLANK(M32)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B33)=TRUE,\"No PO\",IF(M33<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K33=\"Yes\",'PO Scoring Summary'!$E$7,IF(K33=\"No\",0,\"\"))","v":""},{"$f":"IF(L33=\"Yes\",'PO Scoring Summary'!$F$7,IF(L33=\"No\",0,\"\"))","v":""},{"$f":"IF(N33=\"\",\"\",IF(N33=\"Yes\",'PO Scoring Summary'!$G$7,IF(P33=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q33=\"\",\"\",IF(Q33=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q33=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M33=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M33=\"No\",M33=\"N/A\"),0,IF(ISBLANK(M33)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B34)=0,\"\",COUNTIF(line_review_PO,B34))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B34)=TRUE,\"\",IF(AND(I34=O34,P34=0),\"Yes\",IF(AND(O34=0,P34>0),\"No\",\"Needs Improvement\")))","v":""},{"$f":"COUNTIFS(line_review_PO,B34,clear_desc,\"=Yes\")","v":0},{"$f":"COUNTIFS(line_review_PO,B34,clear_desc,\"<>Yes\")","v":0},{"$f":"IF(ISBLANK(B34)=TRUE,\"\",IF(AND(I34=R34,S34=0),\"Yes\",IF(R34=0,\"No\",\"Needs Improvement\")))","v":""},{"$f":"COUNTIFS(line_review_PO,B34,correct_3,\"Yes\")","v":0},{"$f":"COUNTIFS(line_review_PO,B34,correct_3,\"Needs Improvement\")","v":0},{"$f":"IF(ISBLANK(B34)=TRUE,\"\",IF(AA34>0,\"\",SUM(V34:Z34)))","v":""},{"$f":"IF(ISBLANK(B34)=TRUE,\"No PO\",IF(M34<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K34=\"Yes\",'PO Scoring Summary'!$E$7,IF(K34=\"No\",0,\"\"))","v":""},{"$f":"IF(L34=\"Yes\",'PO Scoring Summary'!$F$7,IF(L34=\"No\",0,\"\"))","v":""},{"$f":"IF(N34=\"\",\"\",IF(N34=\"Yes\",'PO Scoring Summary'!$G$7,IF(P34=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q34=\"\",\"\",IF(Q34=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q34=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M34=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M34=\"No\",M34=\"N/A\"),0,IF(ISBLANK(M34)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},{"$f":"COUNTIF(K34:M34,\"\")","v":3}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B35)=TRUE,\"No PO\",IF(M35<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K35=\"Yes\",'PO Scoring Summary'!$E$7,IF(K35=\"No\",0,\"\"))","v":""},{"$f":"IF(L35=\"Yes\",'PO Scoring Summary'!$F$7,IF(L35=\"No\",0,\"\"))","v":""},{"$f":"IF(N35=\"\",\"\",IF(N35=\"Yes\",'PO Scoring Summary'!$G$7,IF(P35=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q35=\"\",\"\",IF(Q35=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q35=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M35=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M35=\"No\",M35=\"N/A\"),0,IF(ISBLANK(M35)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B36)=TRUE,\"No PO\",IF(M36<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K36=\"Yes\",'PO Scoring Summary'!$E$7,IF(K36=\"No\",0,\"\"))","v":""},{"$f":"IF(L36=\"Yes\",'PO Scoring Summary'!$F$7,IF(L36=\"No\",0,\"\"))","v":""},{"$f":"IF(N36=\"\",\"\",IF(N36=\"Yes\",'PO Scoring Summary'!$G$7,IF(P36=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q36=\"\",\"\",IF(Q36=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q36=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M36=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M36=\"No\",M36=\"N/A\"),0,IF(ISBLANK(M36)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B37)=TRUE,\"No PO\",IF(M37<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K37=\"Yes\",'PO Scoring Summary'!$E$7,IF(K37=\"No\",0,\"\"))","v":""},{"$f":"IF(L37=\"Yes\",'PO Scoring Summary'!$F$7,IF(L37=\"No\",0,\"\"))","v":""},{"$f":"IF(N37=\"\",\"\",IF(N37=\"Yes\",'PO Scoring Summary'!$G$7,IF(P37=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q37=\"\",\"\",IF(Q37=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q37=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M37=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M37=\"No\",M37=\"N/A\"),0,IF(ISBLANK(M37)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B38)=TRUE,\"No PO\",IF(M38<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K38=\"Yes\",'PO Scoring Summary'!$E$7,IF(K38=\"No\",0,\"\"))","v":""},{"$f":"IF(L38=\"Yes\",'PO Scoring Summary'!$F$7,IF(L38=\"No\",0,\"\"))","v":""},{"$f":"IF(N38=\"\",\"\",IF(N38=\"Yes\",'PO Scoring Summary'!$G$7,IF(P38=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q38=\"\",\"\",IF(Q38=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q38=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M38=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M38=\"No\",M38=\"N/A\"),0,IF(ISBLANK(M38)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B39)=TRUE,\"No PO\",IF(M39<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K39=\"Yes\",'PO Scoring Summary'!$E$7,IF(K39=\"No\",0,\"\"))","v":""},{"$f":"IF(L39=\"Yes\",'PO Scoring Summary'!$F$7,IF(L39=\"No\",0,\"\"))","v":""},{"$f":"IF(N39=\"\",\"\",IF(N39=\"Yes\",'PO Scoring Summary'!$G$7,IF(P39=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q39=\"\",\"\",IF(Q39=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q39=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M39=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M39=\"No\",M39=\"N/A\"),0,IF(ISBLANK(M39)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B40)=TRUE,\"No PO\",IF(M40<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K40=\"Yes\",'PO Scoring Summary'!$E$7,IF(K40=\"No\",0,\"\"))","v":""},{"$f":"IF(L40=\"Yes\",'PO Scoring Summary'!$F$7,IF(L40=\"No\",0,\"\"))","v":""},{"$f":"IF(N40=\"\",\"\",IF(N40=\"Yes\",'PO Scoring Summary'!$G$7,IF(P40=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q40=\"\",\"\",IF(Q40=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q40=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M40=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M40=\"No\",M40=\"N/A\"),0,IF(ISBLANK(M40)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B41)=TRUE,\"No PO\",IF(M41<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K41=\"Yes\",'PO Scoring Summary'!$E$7,IF(K41=\"No\",0,\"\"))","v":""},{"$f":"IF(L41=\"Yes\",'PO Scoring Summary'!$F$7,IF(L41=\"No\",0,\"\"))","v":""},{"$f":"IF(N41=\"\",\"\",IF(N41=\"Yes\",'PO Scoring Summary'!$G$7,IF(P41=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q41=\"\",\"\",IF(Q41=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q41=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M41=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M41=\"No\",M41=\"N/A\"),0,IF(ISBLANK(M41)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B42)=TRUE,\"No PO\",IF(M42<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K42=\"Yes\",'PO Scoring Summary'!$E$7,IF(K42=\"No\",0,\"\"))","v":""},{"$f":"IF(L42=\"Yes\",'PO Scoring Summary'!$F$7,IF(L42=\"No\",0,\"\"))","v":""},{"$f":"IF(N42=\"\",\"\",IF(N42=\"Yes\",'PO Scoring Summary'!$G$7,IF(P42=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q42=\"\",\"\",IF(Q42=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q42=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M42=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M42=\"No\",M42=\"N/A\"),0,IF(ISBLANK(M42)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B43)=TRUE,\"No PO\",IF(M43<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K43=\"Yes\",'PO Scoring Summary'!$E$7,IF(K43=\"No\",0,\"\"))","v":""},{"$f":"IF(L43=\"Yes\",'PO Scoring Summary'!$F$7,IF(L43=\"No\",0,\"\"))","v":""},{"$f":"IF(N43=\"\",\"\",IF(N43=\"Yes\",'PO Scoring Summary'!$G$7,IF(P43=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q43=\"\",\"\",IF(Q43=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q43=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M43=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M43=\"No\",M43=\"N/A\"),0,IF(ISBLANK(M43)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B44)=TRUE,\"No PO\",IF(M44<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K44=\"Yes\",'PO Scoring Summary'!$E$7,IF(K44=\"No\",0,\"\"))","v":""},{"$f":"IF(L44=\"Yes\",'PO Scoring Summary'!$F$7,IF(L44=\"No\",0,\"\"))","v":""},{"$f":"IF(N44=\"\",\"\",IF(N44=\"Yes\",'PO Scoring Summary'!$G$7,IF(P44=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q44=\"\",\"\",IF(Q44=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q44=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M44=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M44=\"No\",M44=\"N/A\"),0,IF(ISBLANK(M44)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B45)=TRUE,\"No PO\",IF(M45<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K45=\"Yes\",'PO Scoring Summary'!$E$7,IF(K45=\"No\",0,\"\"))","v":""},{"$f":"IF(L45=\"Yes\",'PO Scoring Summary'!$F$7,IF(L45=\"No\",0,\"\"))","v":""},{"$f":"IF(N45=\"\",\"\",IF(N45=\"Yes\",'PO Scoring Summary'!$G$7,IF(P45=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q45=\"\",\"\",IF(Q45=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q45=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M45=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M45=\"No\",M45=\"N/A\"),0,IF(ISBLANK(M45)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B46)=TRUE,\"No PO\",IF(M46<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K46=\"Yes\",'PO Scoring Summary'!$E$7,IF(K46=\"No\",0,\"\"))","v":""},{"$f":"IF(L46=\"Yes\",'PO Scoring Summary'!$F$7,IF(L46=\"No\",0,\"\"))","v":""},{"$f":"IF(N46=\"\",\"\",IF(N46=\"Yes\",'PO Scoring Summary'!$G$7,IF(P46=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q46=\"\",\"\",IF(Q46=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q46=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M46=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M46=\"No\",M46=\"N/A\"),0,IF(ISBLANK(M46)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B47)=TRUE,\"No PO\",IF(M47<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K47=\"Yes\",'PO Scoring Summary'!$E$7,IF(K47=\"No\",0,\"\"))","v":""},{"$f":"IF(L47=\"Yes\",'PO Scoring Summary'!$F$7,IF(L47=\"No\",0,\"\"))","v":""},{"$f":"IF(N47=\"\",\"\",IF(N47=\"Yes\",'PO Scoring Summary'!$G$7,IF(P47=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q47=\"\",\"\",IF(Q47=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q47=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M47=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M47=\"No\",M47=\"N/A\"),0,IF(ISBLANK(M47)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B48)=TRUE,\"No PO\",IF(M48<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K48=\"Yes\",'PO Scoring Summary'!$E$7,IF(K48=\"No\",0,\"\"))","v":""},{"$f":"IF(L48=\"Yes\",'PO Scoring Summary'!$F$7,IF(L48=\"No\",0,\"\"))","v":""},{"$f":"IF(N48=\"\",\"\",IF(N48=\"Yes\",'PO Scoring Summary'!$G$7,IF(P48=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q48=\"\",\"\",IF(Q48=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q48=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M48=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M48=\"No\",M48=\"N/A\"),0,IF(ISBLANK(M48)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B49)=TRUE,\"No PO\",IF(M49<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K49=\"Yes\",'PO Scoring Summary'!$E$7,IF(K49=\"No\",0,\"\"))","v":""},{"$f":"IF(L49=\"Yes\",'PO Scoring Summary'!$F$7,IF(L49=\"No\",0,\"\"))","v":""},{"$f":"IF(N49=\"\",\"\",IF(N49=\"Yes\",'PO Scoring Summary'!$G$7,IF(P49=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q49=\"\",\"\",IF(Q49=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q49=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M49=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M49=\"No\",M49=\"N/A\"),0,IF(ISBLANK(M49)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B50)=TRUE,\"No PO\",IF(M50<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K50=\"Yes\",'PO Scoring Summary'!$E$7,IF(K50=\"No\",0,\"\"))","v":""},{"$f":"IF(L50=\"Yes\",'PO Scoring Summary'!$F$7,IF(L50=\"No\",0,\"\"))","v":""},{"$f":"IF(N50=\"\",\"\",IF(N50=\"Yes\",'PO Scoring Summary'!$G$7,IF(P50=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q50=\"\",\"\",IF(Q50=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q50=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M50=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M50=\"No\",M50=\"N/A\"),0,IF(ISBLANK(M50)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B51)=TRUE,\"No PO\",IF(M51<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K51=\"Yes\",'PO Scoring Summary'!$E$7,IF(K51=\"No\",0,\"\"))","v":""},{"$f":"IF(L51=\"Yes\",'PO Scoring Summary'!$F$7,IF(L51=\"No\",0,\"\"))","v":""},{"$f":"IF(N51=\"\",\"\",IF(N51=\"Yes\",'PO Scoring Summary'!$G$7,IF(P51=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q51=\"\",\"\",IF(Q51=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q51=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M51=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M51=\"No\",M51=\"N/A\"),0,IF(ISBLANK(M51)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B52)=TRUE,\"No PO\",IF(M52<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K52=\"Yes\",'PO Scoring Summary'!$E$7,IF(K52=\"No\",0,\"\"))","v":""},{"$f":"IF(L52=\"Yes\",'PO Scoring Summary'!$F$7,IF(L52=\"No\",0,\"\"))","v":""},{"$f":"IF(N52=\"\",\"\",IF(N52=\"Yes\",'PO Scoring Summary'!$G$7,IF(P52=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q52=\"\",\"\",IF(Q52=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q52=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M52=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M52=\"No\",M52=\"N/A\"),0,IF(ISBLANK(M52)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},{"$f":"COUNTIF(K52:M52,\"\")","v":3}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B53)=TRUE,\"No PO\",IF(M53<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K53=\"Yes\",'PO Scoring Summary'!$E$7,IF(K53=\"No\",0,\"\"))","v":""},{"$f":"IF(L53=\"Yes\",'PO Scoring Summary'!$F$7,IF(L53=\"No\",0,\"\"))","v":""},{"$f":"IF(N53=\"\",\"\",IF(N53=\"Yes\",'PO Scoring Summary'!$G$7,IF(P53=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q53=\"\",\"\",IF(Q53=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q53=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M53=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M53=\"No\",M53=\"N/A\"),0,IF(ISBLANK(M53)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B54)=TRUE,\"No PO\",IF(M54<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K54=\"Yes\",'PO Scoring Summary'!$E$7,IF(K54=\"No\",0,\"\"))","v":""},{"$f":"IF(L54=\"Yes\",'PO Scoring Summary'!$F$7,IF(L54=\"No\",0,\"\"))","v":""},{"$f":"IF(N54=\"\",\"\",IF(N54=\"Yes\",'PO Scoring Summary'!$G$7,IF(P54=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q54=\"\",\"\",IF(Q54=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q54=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M54=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M54=\"No\",M54=\"N/A\"),0,IF(ISBLANK(M54)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B55)=TRUE,\"No PO\",IF(M55<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K55=\"Yes\",'PO Scoring Summary'!$E$7,IF(K55=\"No\",0,\"\"))","v":""},{"$f":"IF(L55=\"Yes\",'PO Scoring Summary'!$F$7,IF(L55=\"No\",0,\"\"))","v":""},{"$f":"IF(N55=\"\",\"\",IF(N55=\"Yes\",'PO Scoring Summary'!$G$7,IF(P55=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q55=\"\",\"\",IF(Q55=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q55=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M55=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M55=\"No\",M55=\"N/A\"),0,IF(ISBLANK(M55)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B56)=TRUE,\"No PO\",IF(M56<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K56=\"Yes\",'PO Scoring Summary'!$E$7,IF(K56=\"No\",0,\"\"))","v":""},{"$f":"IF(L56=\"Yes\",'PO Scoring Summary'!$F$7,IF(L56=\"No\",0,\"\"))","v":""},{"$f":"IF(N56=\"\",\"\",IF(N56=\"Yes\",'PO Scoring Summary'!$G$7,IF(P56=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q56=\"\",\"\",IF(Q56=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q56=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M56=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M56=\"No\",M56=\"N/A\"),0,IF(ISBLANK(M56)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B57)=TRUE,\"No PO\",IF(M57<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K57=\"Yes\",'PO Scoring Summary'!$E$7,IF(K57=\"No\",0,\"\"))","v":""},{"$f":"IF(L57=\"Yes\",'PO Scoring Summary'!$F$7,IF(L57=\"No\",0,\"\"))","v":""},{"$f":"IF(N57=\"\",\"\",IF(N57=\"Yes\",'PO Scoring Summary'!$G$7,IF(P57=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q57=\"\",\"\",IF(Q57=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q57=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M57=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M57=\"No\",M57=\"N/A\"),0,IF(ISBLANK(M57)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B58)=TRUE,\"No PO\",IF(M58<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K58=\"Yes\",'PO Scoring Summary'!$E$7,IF(K58=\"No\",0,\"\"))","v":""},{"$f":"IF(L58=\"Yes\",'PO Scoring Summary'!$F$7,IF(L58=\"No\",0,\"\"))","v":""},{"$f":"IF(N58=\"\",\"\",IF(N58=\"Yes\",'PO Scoring Summary'!$G$7,IF(P58=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q58=\"\",\"\",IF(Q58=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q58=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M58=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M58=\"No\",M58=\"N/A\"),0,IF(ISBLANK(M58)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B59)=TRUE,\"No PO\",IF(M59<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K59=\"Yes\",'PO Scoring Summary'!$E$7,IF(K59=\"No\",0,\"\"))","v":""},{"$f":"IF(L59=\"Yes\",'PO Scoring Summary'!$F$7,IF(L59=\"No\",0,\"\"))","v":""},{"$f":"IF(N59=\"\",\"\",IF(N59=\"Yes\",'PO Scoring Summary'!$G$7,IF(P59=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q59=\"\",\"\",IF(Q59=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q59=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M59=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M59=\"No\",M59=\"N/A\"),0,IF(ISBLANK(M59)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B60)=TRUE,\"No PO\",IF(M60<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K60=\"Yes\",'PO Scoring Summary'!$E$7,IF(K60=\"No\",0,\"\"))","v":""},{"$f":"IF(L60=\"Yes\",'PO Scoring Summary'!$F$7,IF(L60=\"No\",0,\"\"))","v":""},{"$f":"IF(N60=\"\",\"\",IF(N60=\"Yes\",'PO Scoring Summary'!$G$7,IF(P60=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q60=\"\",\"\",IF(Q60=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q60=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M60=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M60=\"No\",M60=\"N/A\"),0,IF(ISBLANK(M60)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B61)=TRUE,\"No PO\",IF(M61<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K61=\"Yes\",'PO Scoring Summary'!$E$7,IF(K61=\"No\",0,\"\"))","v":""},{"$f":"IF(L61=\"Yes\",'PO Scoring Summary'!$F$7,IF(L61=\"No\",0,\"\"))","v":""},{"$f":"IF(N61=\"\",\"\",IF(N61=\"Yes\",'PO Scoring Summary'!$G$7,IF(P61=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q61=\"\",\"\",IF(Q61=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q61=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M61=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M61=\"No\",M61=\"N/A\"),0,IF(ISBLANK(M61)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B62)=TRUE,\"No PO\",IF(M62<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K62=\"Yes\",'PO Scoring Summary'!$E$7,IF(K62=\"No\",0,\"\"))","v":""},{"$f":"IF(L62=\"Yes\",'PO Scoring Summary'!$F$7,IF(L62=\"No\",0,\"\"))","v":""},{"$f":"IF(N62=\"\",\"\",IF(N62=\"Yes\",'PO Scoring Summary'!$G$7,IF(P62=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q62=\"\",\"\",IF(Q62=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q62=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M62=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M62=\"No\",M62=\"N/A\"),0,IF(ISBLANK(M62)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B63)=TRUE,\"No PO\",IF(M63<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K63=\"Yes\",'PO Scoring Summary'!$E$7,IF(K63=\"No\",0,\"\"))","v":""},{"$f":"IF(L63=\"Yes\",'PO Scoring Summary'!$F$7,IF(L63=\"No\",0,\"\"))","v":""},{"$f":"IF(N63=\"\",\"\",IF(N63=\"Yes\",'PO Scoring Summary'!$G$7,IF(P63=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q63=\"\",\"\",IF(Q63=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q63=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M63=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M63=\"No\",M63=\"N/A\"),0,IF(ISBLANK(M63)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B64)=TRUE,\"No PO\",IF(M64<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K64=\"Yes\",'PO Scoring Summary'!$E$7,IF(K64=\"No\",0,\"\"))","v":""},{"$f":"IF(L64=\"Yes\",'PO Scoring Summary'!$F$7,IF(L64=\"No\",0,\"\"))","v":""},{"$f":"IF(N64=\"\",\"\",IF(N64=\"Yes\",'PO Scoring Summary'!$G$7,IF(P64=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q64=\"\",\"\",IF(Q64=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q64=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M64=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M64=\"No\",M64=\"N/A\"),0,IF(ISBLANK(M64)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B65)=TRUE,\"No PO\",IF(M65<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K65=\"Yes\",'PO Scoring Summary'!$E$7,IF(K65=\"No\",0,\"\"))","v":""},{"$f":"IF(L65=\"Yes\",'PO Scoring Summary'!$F$7,IF(L65=\"No\",0,\"\"))","v":""},{"$f":"IF(N65=\"\",\"\",IF(N65=\"Yes\",'PO Scoring Summary'!$G$7,IF(P65=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q65=\"\",\"\",IF(Q65=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q65=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M65=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M65=\"No\",M65=\"N/A\"),0,IF(ISBLANK(M65)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B66)=0,\"\",COUNTIF(line_review_PO,B66))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B66)=TRUE,\"\",IF(AND(I66=O66,P66=0),\"Yes\",IF(AND(O66=0,P66>0),\"No\",\"Needs Improvement\")))","v":""},{"$f":"COUNTIFS(line_review_PO,B66,clear_desc,\"=Yes\")","v":0},{"$f":"COUNTIFS(line_review_PO,B66,clear_desc,\"<>Yes\")","v":0},{"$f":"IF(ISBLANK(B66)=TRUE,\"\",IF(AND(I66=R66,S66=0),\"Yes\",IF(R66=0,\"No\",\"Needs Improvement\")))","v":""},{"$f":"COUNTIFS(line_review_PO,B66,correct_3,\"Yes\")","v":0},{"$f":"COUNTIFS(line_review_PO,B66,correct_3,\"Needs Improvement\")","v":0},{"$f":"IF(ISBLANK(B66)=TRUE,\"\",IF(AA66>0,\"\",SUM(V66:Z66)))","v":""},{"$f":"IF(ISBLANK(B66)=TRUE,\"No PO\",IF(M66<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K66=\"Yes\",'PO Scoring Summary'!$E$7,IF(K66=\"No\",0,\"\"))","v":""},{"$f":"IF(L66=\"Yes\",'PO Scoring Summary'!$F$7,IF(L66=\"No\",0,\"\"))","v":""},{"$f":"IF(N66=\"\",\"\",IF(N66=\"Yes\",'PO Scoring Summary'!$G$7,IF(P66=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q66=\"\",\"\",IF(Q66=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q66=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M66=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M66=\"No\",M66=\"N/A\"),0,IF(ISBLANK(M66)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B67)=TRUE,\"No PO\",IF(M67<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K67=\"Yes\",'PO Scoring Summary'!$E$7,IF(K67=\"No\",0,\"\"))","v":""},{"$f":"IF(L67=\"Yes\",'PO Scoring Summary'!$F$7,IF(L67=\"No\",0,\"\"))","v":""},{"$f":"IF(N67=\"\",\"\",IF(N67=\"Yes\",'PO Scoring Summary'!$G$7,IF(P67=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q67=\"\",\"\",IF(Q67=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q67=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M67=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M67=\"No\",M67=\"N/A\"),0,IF(ISBLANK(M67)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B68)=TRUE,\"No PO\",IF(M68<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K68=\"Yes\",'PO Scoring Summary'!$E$7,IF(K68=\"No\",0,\"\"))","v":""},{"$f":"IF(L68=\"Yes\",'PO Scoring Summary'!$F$7,IF(L68=\"No\",0,\"\"))","v":""},{"$f":"IF(N68=\"\",\"\",IF(N68=\"Yes\",'PO Scoring Summary'!$G$7,IF(P68=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q68=\"\",\"\",IF(Q68=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q68=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M68=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M68=\"No\",M68=\"N/A\"),0,IF(ISBLANK(M68)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B69)=TRUE,\"No PO\",IF(M69<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K69=\"Yes\",'PO Scoring Summary'!$E$7,IF(K69=\"No\",0,\"\"))","v":""},{"$f":"IF(L69=\"Yes\",'PO Scoring Summary'!$F$7,IF(L69=\"No\",0,\"\"))","v":""},{"$f":"IF(N69=\"\",\"\",IF(N69=\"Yes\",'PO Scoring Summary'!$G$7,IF(P69=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q69=\"\",\"\",IF(Q69=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q69=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M69=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M69=\"No\",M69=\"N/A\"),0,IF(ISBLANK(M69)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B70)=TRUE,\"No PO\",IF(M70<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K70=\"Yes\",'PO Scoring Summary'!$E$7,IF(K70=\"No\",0,\"\"))","v":""},{"$f":"IF(L70=\"Yes\",'PO Scoring Summary'!$F$7,IF(L70=\"No\",0,\"\"))","v":""},{"$f":"IF(N70=\"\",\"\",IF(N70=\"Yes\",'PO Scoring Summary'!$G$7,IF(P70=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q70=\"\",\"\",IF(Q70=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q70=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M70=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M70=\"No\",M70=\"N/A\"),0,IF(ISBLANK(M70)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B71)=TRUE,\"No PO\",IF(M71<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K71=\"Yes\",'PO Scoring Summary'!$E$7,IF(K71=\"No\",0,\"\"))","v":""},{"$f":"IF(L71=\"Yes\",'PO Scoring Summary'!$F$7,IF(L71=\"No\",0,\"\"))","v":""},{"$f":"IF(N71=\"\",\"\",IF(N71=\"Yes\",'PO Scoring Summary'!$G$7,IF(P71=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q71=\"\",\"\",IF(Q71=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q71=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M71=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M71=\"No\",M71=\"N/A\"),0,IF(ISBLANK(M71)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B72)=TRUE,\"No PO\",IF(M72<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K72=\"Yes\",'PO Scoring Summary'!$E$7,IF(K72=\"No\",0,\"\"))","v":""},{"$f":"IF(L72=\"Yes\",'PO Scoring Summary'!$F$7,IF(L72=\"No\",0,\"\"))","v":""},{"$f":"IF(N72=\"\",\"\",IF(N72=\"Yes\",'PO Scoring Summary'!$G$7,IF(P72=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q72=\"\",\"\",IF(Q72=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q72=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M72=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M72=\"No\",M72=\"N/A\"),0,IF(ISBLANK(M72)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B73)=TRUE,\"No PO\",IF(M73<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K73=\"Yes\",'PO Scoring Summary'!$E$7,IF(K73=\"No\",0,\"\"))","v":""},{"$f":"IF(L73=\"Yes\",'PO Scoring Summary'!$F$7,IF(L73=\"No\",0,\"\"))","v":""},{"$f":"IF(N73=\"\",\"\",IF(N73=\"Yes\",'PO Scoring Summary'!$G$7,IF(P73=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q73=\"\",\"\",IF(Q73=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q73=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M73=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M73=\"No\",M73=\"N/A\"),0,IF(ISBLANK(M73)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B74)=TRUE,\"No PO\",IF(M74<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K74=\"Yes\",'PO Scoring Summary'!$E$7,IF(K74=\"No\",0,\"\"))","v":""},{"$f":"IF(L74=\"Yes\",'PO Scoring Summary'!$F$7,IF(L74=\"No\",0,\"\"))","v":""},{"$f":"IF(N74=\"\",\"\",IF(N74=\"Yes\",'PO Scoring Summary'!$G$7,IF(P74=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q74=\"\",\"\",IF(Q74=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q74=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M74=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M74=\"No\",M74=\"N/A\"),0,IF(ISBLANK(M74)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B75)=TRUE,\"No PO\",IF(M75<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K75=\"Yes\",'PO Scoring Summary'!$E$7,IF(K75=\"No\",0,\"\"))","v":""},{"$f":"IF(L75=\"Yes\",'PO Scoring Summary'!$F$7,IF(L75=\"No\",0,\"\"))","v":""},{"$f":"IF(N75=\"\",\"\",IF(N75=\"Yes\",'PO Scoring Summary'!$G$7,IF(P75=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q75=\"\",\"\",IF(Q75=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q75=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M75=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M75=\"No\",M75=\"N/A\"),0,IF(ISBLANK(M75)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B76)=TRUE,\"No PO\",IF(M76<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K76=\"Yes\",'PO Scoring Summary'!$E$7,IF(K76=\"No\",0,\"\"))","v":""},{"$f":"IF(L76=\"Yes\",'PO Scoring Summary'!$F$7,IF(L76=\"No\",0,\"\"))","v":""},{"$f":"IF(N76=\"\",\"\",IF(N76=\"Yes\",'PO Scoring Summary'!$G$7,IF(P76=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q76=\"\",\"\",IF(Q76=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q76=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M76=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M76=\"No\",M76=\"N/A\"),0,IF(ISBLANK(M76)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B77)=TRUE,\"No PO\",IF(M77<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K77=\"Yes\",'PO Scoring Summary'!$E$7,IF(K77=\"No\",0,\"\"))","v":""},{"$f":"IF(L77=\"Yes\",'PO Scoring Summary'!$F$7,IF(L77=\"No\",0,\"\"))","v":""},{"$f":"IF(N77=\"\",\"\",IF(N77=\"Yes\",'PO Scoring Summary'!$G$7,IF(P77=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q77=\"\",\"\",IF(Q77=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q77=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M77=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M77=\"No\",M77=\"N/A\"),0,IF(ISBLANK(M77)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},{"$f":"COUNTIF(K77:M77,\"\")","v":3}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B78)=TRUE,\"No PO\",IF(M78<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K78=\"Yes\",'PO Scoring Summary'!$E$7,IF(K78=\"No\",0,\"\"))","v":""},{"$f":"IF(L78=\"Yes\",'PO Scoring Summary'!$F$7,IF(L78=\"No\",0,\"\"))","v":""},{"$f":"IF(N78=\"\",\"\",IF(N78=\"Yes\",'PO Scoring Summary'!$G$7,IF(P78=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q78=\"\",\"\",IF(Q78=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q78=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M78=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M78=\"No\",M78=\"N/A\"),0,IF(ISBLANK(M78)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B79)=TRUE,\"No PO\",IF(M79<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K79=\"Yes\",'PO Scoring Summary'!$E$7,IF(K79=\"No\",0,\"\"))","v":""},{"$f":"IF(L79=\"Yes\",'PO Scoring Summary'!$F$7,IF(L79=\"No\",0,\"\"))","v":""},{"$f":"IF(N79=\"\",\"\",IF(N79=\"Yes\",'PO Scoring Summary'!$G$7,IF(P79=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q79=\"\",\"\",IF(Q79=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q79=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M79=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M79=\"No\",M79=\"N/A\"),0,IF(ISBLANK(M79)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B80)=TRUE,\"No PO\",IF(M80<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K80=\"Yes\",'PO Scoring Summary'!$E$7,IF(K80=\"No\",0,\"\"))","v":""},{"$f":"IF(L80=\"Yes\",'PO Scoring Summary'!$F$7,IF(L80=\"No\",0,\"\"))","v":""},{"$f":"IF(N80=\"\",\"\",IF(N80=\"Yes\",'PO Scoring Summary'!$G$7,IF(P80=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q80=\"\",\"\",IF(Q80=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q80=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M80=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M80=\"No\",M80=\"N/A\"),0,IF(ISBLANK(M80)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B81)=TRUE,\"No PO\",IF(M81<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K81=\"Yes\",'PO Scoring Summary'!$E$7,IF(K81=\"No\",0,\"\"))","v":""},{"$f":"IF(L81=\"Yes\",'PO Scoring Summary'!$F$7,IF(L81=\"No\",0,\"\"))","v":""},{"$f":"IF(N81=\"\",\"\",IF(N81=\"Yes\",'PO Scoring Summary'!$G$7,IF(P81=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q81=\"\",\"\",IF(Q81=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q81=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M81=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M81=\"No\",M81=\"N/A\"),0,IF(ISBLANK(M81)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B82)=TRUE,\"No PO\",IF(M82<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K82=\"Yes\",'PO Scoring Summary'!$E$7,IF(K82=\"No\",0,\"\"))","v":""},{"$f":"IF(L82=\"Yes\",'PO Scoring Summary'!$F$7,IF(L82=\"No\",0,\"\"))","v":""},{"$f":"IF(N82=\"\",\"\",IF(N82=\"Yes\",'PO Scoring Summary'!$G$7,IF(P82=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q82=\"\",\"\",IF(Q82=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q82=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M82=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M82=\"No\",M82=\"N/A\"),0,IF(ISBLANK(M82)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B83)=TRUE,\"No PO\",IF(M83<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K83=\"Yes\",'PO Scoring Summary'!$E$7,IF(K83=\"No\",0,\"\"))","v":""},{"$f":"IF(L83=\"Yes\",'PO Scoring Summary'!$F$7,IF(L83=\"No\",0,\"\"))","v":""},{"$f":"IF(N83=\"\",\"\",IF(N83=\"Yes\",'PO Scoring Summary'!$G$7,IF(P83=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q83=\"\",\"\",IF(Q83=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q83=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M83=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M83=\"No\",M83=\"N/A\"),0,IF(ISBLANK(M83)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B84)=TRUE,\"No PO\",IF(M84<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K84=\"Yes\",'PO Scoring Summary'!$E$7,IF(K84=\"No\",0,\"\"))","v":""},{"$f":"IF(L84=\"Yes\",'PO Scoring Summary'!$F$7,IF(L84=\"No\",0,\"\"))","v":""},{"$f":"IF(N84=\"\",\"\",IF(N84=\"Yes\",'PO Scoring Summary'!$G$7,IF(P84=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q84=\"\",\"\",IF(Q84=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q84=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M84=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M84=\"No\",M84=\"N/A\"),0,IF(ISBLANK(M84)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B85)=TRUE,\"No PO\",IF(M85<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K85=\"Yes\",'PO Scoring Summary'!$E$7,IF(K85=\"No\",0,\"\"))","v":""},{"$f":"IF(L85=\"Yes\",'PO Scoring Summary'!$F$7,IF(L85=\"No\",0,\"\"))","v":""},{"$f":"IF(N85=\"\",\"\",IF(N85=\"Yes\",'PO Scoring Summary'!$G$7,IF(P85=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q85=\"\",\"\",IF(Q85=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q85=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M85=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M85=\"No\",M85=\"N/A\"),0,IF(ISBLANK(M85)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B86)=TRUE,\"No PO\",IF(M86<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K86=\"Yes\",'PO Scoring Summary'!$E$7,IF(K86=\"No\",0,\"\"))","v":""},{"$f":"IF(L86=\"Yes\",'PO Scoring Summary'!$F$7,IF(L86=\"No\",0,\"\"))","v":""},{"$f":"IF(N86=\"\",\"\",IF(N86=\"Yes\",'PO Scoring Summary'!$G$7,IF(P86=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q86=\"\",\"\",IF(Q86=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q86=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M86=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M86=\"No\",M86=\"N/A\"),0,IF(ISBLANK(M86)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B87)=TRUE,\"No PO\",IF(M87<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K87=\"Yes\",'PO Scoring Summary'!$E$7,IF(K87=\"No\",0,\"\"))","v":""},{"$f":"IF(L87=\"Yes\",'PO Scoring Summary'!$F$7,IF(L87=\"No\",0,\"\"))","v":""},{"$f":"IF(N87=\"\",\"\",IF(N87=\"Yes\",'PO Scoring Summary'!$G$7,IF(P87=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q87=\"\",\"\",IF(Q87=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q87=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M87=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M87=\"No\",M87=\"N/A\"),0,IF(ISBLANK(M87)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B88)=TRUE,\"No PO\",IF(M88<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K88=\"Yes\",'PO Scoring Summary'!$E$7,IF(K88=\"No\",0,\"\"))","v":""},{"$f":"IF(L88=\"Yes\",'PO Scoring Summary'!$F$7,IF(L88=\"No\",0,\"\"))","v":""},{"$f":"IF(N88=\"\",\"\",IF(N88=\"Yes\",'PO Scoring Summary'!$G$7,IF(P88=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q88=\"\",\"\",IF(Q88=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q88=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M88=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M88=\"No\",M88=\"N/A\"),0,IF(ISBLANK(M88)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B89)=TRUE,\"No PO\",IF(M89<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K89=\"Yes\",'PO Scoring Summary'!$E$7,IF(K89=\"No\",0,\"\"))","v":""},{"$f":"IF(L89=\"Yes\",'PO Scoring Summary'!$F$7,IF(L89=\"No\",0,\"\"))","v":""},{"$f":"IF(N89=\"\",\"\",IF(N89=\"Yes\",'PO Scoring Summary'!$G$7,IF(P89=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q89=\"\",\"\",IF(Q89=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q89=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M89=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M89=\"No\",M89=\"N/A\"),0,IF(ISBLANK(M89)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B90)=TRUE,\"No PO\",IF(M90<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K90=\"Yes\",'PO Scoring Summary'!$E$7,IF(K90=\"No\",0,\"\"))","v":""},{"$f":"IF(L90=\"Yes\",'PO Scoring Summary'!$F$7,IF(L90=\"No\",0,\"\"))","v":""},{"$f":"IF(N90=\"\",\"\",IF(N90=\"Yes\",'PO Scoring Summary'!$G$7,IF(P90=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q90=\"\",\"\",IF(Q90=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q90=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M90=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M90=\"No\",M90=\"N/A\"),0,IF(ISBLANK(M90)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B91)=TRUE,\"No PO\",IF(M91<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K91=\"Yes\",'PO Scoring Summary'!$E$7,IF(K91=\"No\",0,\"\"))","v":""},{"$f":"IF(L91=\"Yes\",'PO Scoring Summary'!$F$7,IF(L91=\"No\",0,\"\"))","v":""},{"$f":"IF(N91=\"\",\"\",IF(N91=\"Yes\",'PO Scoring Summary'!$G$7,IF(P91=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q91=\"\",\"\",IF(Q91=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q91=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M91=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M91=\"No\",M91=\"N/A\"),0,IF(ISBLANK(M91)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B92)=TRUE,\"No PO\",IF(M92<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K92=\"Yes\",'PO Scoring Summary'!$E$7,IF(K92=\"No\",0,\"\"))","v":""},{"$f":"IF(L92=\"Yes\",'PO Scoring Summary'!$F$7,IF(L92=\"No\",0,\"\"))","v":""},{"$f":"IF(N92=\"\",\"\",IF(N92=\"Yes\",'PO Scoring Summary'!$G$7,IF(P92=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q92=\"\",\"\",IF(Q92=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q92=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M92=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M92=\"No\",M92=\"N/A\"),0,IF(ISBLANK(M92)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B93)=TRUE,\"No PO\",IF(M93<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K93=\"Yes\",'PO Scoring Summary'!$E$7,IF(K93=\"No\",0,\"\"))","v":""},{"$f":"IF(L93=\"Yes\",'PO Scoring Summary'!$F$7,IF(L93=\"No\",0,\"\"))","v":""},{"$f":"IF(N93=\"\",\"\",IF(N93=\"Yes\",'PO Scoring Summary'!$G$7,IF(P93=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q93=\"\",\"\",IF(Q93=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q93=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M93=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M93=\"No\",M93=\"N/A\"),0,IF(ISBLANK(M93)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B94)=TRUE,\"No PO\",IF(M94<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K94=\"Yes\",'PO Scoring Summary'!$E$7,IF(K94=\"No\",0,\"\"))","v":""},{"$f":"IF(L94=\"Yes\",'PO Scoring Summary'!$F$7,IF(L94=\"No\",0,\"\"))","v":""},{"$f":"IF(N94=\"\",\"\",IF(N94=\"Yes\",'PO Scoring Summary'!$G$7,IF(P94=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q94=\"\",\"\",IF(Q94=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q94=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M94=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M94=\"No\",M94=\"N/A\"),0,IF(ISBLANK(M94)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B95)=TRUE,\"No PO\",IF(M95<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K95=\"Yes\",'PO Scoring Summary'!$E$7,IF(K95=\"No\",0,\"\"))","v":""},{"$f":"IF(L95=\"Yes\",'PO Scoring Summary'!$F$7,IF(L95=\"No\",0,\"\"))","v":""},{"$f":"IF(N95=\"\",\"\",IF(N95=\"Yes\",'PO Scoring Summary'!$G$7,IF(P95=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q95=\"\",\"\",IF(Q95=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q95=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M95=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M95=\"No\",M95=\"N/A\"),0,IF(ISBLANK(M95)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B96)=TRUE,\"No PO\",IF(M96<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K96=\"Yes\",'PO Scoring Summary'!$E$7,IF(K96=\"No\",0,\"\"))","v":""},{"$f":"IF(L96=\"Yes\",'PO Scoring Summary'!$F$7,IF(L96=\"No\",0,\"\"))","v":""},{"$f":"IF(N96=\"\",\"\",IF(N96=\"Yes\",'PO Scoring Summary'!$G$7,IF(P96=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q96=\"\",\"\",IF(Q96=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q96=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M96=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M96=\"No\",M96=\"N/A\"),0,IF(ISBLANK(M96)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B97)=TRUE,\"No PO\",IF(M97<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K97=\"Yes\",'PO Scoring Summary'!$E$7,IF(K97=\"No\",0,\"\"))","v":""},{"$f":"IF(L97=\"Yes\",'PO Scoring Summary'!$F$7,IF(L97=\"No\",0,\"\"))","v":""},{"$f":"IF(N97=\"\",\"\",IF(N97=\"Yes\",'PO Scoring Summary'!$G$7,IF(P97=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q97=\"\",\"\",IF(Q97=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q97=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M97=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M97=\"No\",M97=\"N/A\"),0,IF(ISBLANK(M97)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B98)=0,\"\",COUNTIF(line_review_PO,B98))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B98)=TRUE,\"\",IF(AND(I98=O98,P98=0),\"Yes\",IF(AND(O98=0,P98>0),\"No\",\"Needs Improvement\")))","v":""},0,0,{"$f":"IF(ISBLANK(B98)=TRUE,\"\",IF(AND(I98=R98,S98=0),\"Yes\",IF(R98=0,\"No\",\"Needs Improvement\")))","v":""},0,0,"",{"$f":"IF(ISBLANK(B98)=TRUE,\"No PO\",IF(M98<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K98=\"Yes\",'PO Scoring Summary'!$E$7,IF(K98=\"No\",0,\"\"))","v":""},{"$f":"IF(L98=\"Yes\",'PO Scoring Summary'!$F$7,IF(L98=\"No\",0,\"\"))","v":""},{"$f":"IF(N98=\"\",\"\",IF(N98=\"Yes\",'PO Scoring Summary'!$G$7,IF(P98=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q98=\"\",\"\",IF(Q98=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q98=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M98=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M98=\"No\",M98=\"N/A\"),0,IF(ISBLANK(M98)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B99)=TRUE,\"No PO\",IF(M99<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K99=\"Yes\",'PO Scoring Summary'!$E$7,IF(K99=\"No\",0,\"\"))","v":""},{"$f":"IF(L99=\"Yes\",'PO Scoring Summary'!$F$7,IF(L99=\"No\",0,\"\"))","v":""},{"$f":"IF(N99=\"\",\"\",IF(N99=\"Yes\",'PO Scoring Summary'!$G$7,IF(P99=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q99=\"\",\"\",IF(Q99=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q99=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M99=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M99=\"No\",M99=\"N/A\"),0,IF(ISBLANK(M99)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B100)=TRUE,\"No PO\",IF(M100<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K100=\"Yes\",'PO Scoring Summary'!$E$7,IF(K100=\"No\",0,\"\"))","v":""},{"$f":"IF(L100=\"Yes\",'PO Scoring Summary'!$F$7,IF(L100=\"No\",0,\"\"))","v":""},{"$f":"IF(N100=\"\",\"\",IF(N100=\"Yes\",'PO Scoring Summary'!$G$7,IF(P100=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q100=\"\",\"\",IF(Q100=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q100=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M100=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M100=\"No\",M100=\"N/A\"),0,IF(ISBLANK(M100)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",0,0,"",0,0,"",{"$f":"IF(ISBLANK(B101)=TRUE,\"No PO\",IF(M101<>\"N/A\",SUM(max_pts),SUM(max_pts)-'PO Scoring Summary'!$I$7))","v":"No PO"},{"$f":"IF(K101=\"Yes\",'PO Scoring Summary'!$E$7,IF(K101=\"No\",0,\"\"))","v":""},{"$f":"IF(L101=\"Yes\",'PO Scoring Summary'!$F$7,IF(L101=\"No\",0,\"\"))","v":""},{"$f":"IF(N101=\"\",\"\",IF(N101=\"Yes\",'PO Scoring Summary'!$G$7,IF(P101=1,ROUNDUP('PO Scoring Summary'!$G$7*0.5,0),0)))","v":""},{"$f":"IF(Q101=\"\",\"\",IF(Q101=\"Yes\",'PO Scoring Summary'!$H$7,IF(Q101=\"No\",0,ROUNDUP('PO Scoring Summary'!$H$7*0.5,0))))","v":""},{"$f":"IF(M101=\"Yes\",'PO Scoring Summary'!$I$7,IF(OR(M101=\"No\",M101=\"N/A\"),0,IF(ISBLANK(M101)=TRUE,\"\",ROUNDUP('PO Scoring Summary'!$I$7*0.5,0))))","v":""},3]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B130)=0,\"\",COUNTIF(line_review_PO,B130))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B194)=0,\"\",COUNTIF(line_review_PO,B194))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B258)=0,\"\",COUNTIF(line_review_PO,B258))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B322)=0,\"\",COUNTIF(line_review_PO,B322))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B386)=0,\"\",COUNTIF(line_review_PO,B386))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(line_review_PO,B450)=0,\"\",COUNTIF(line_review_PO,B450))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]

{"sheet":"PO Line Review","index":4,"n_rows":1004,"n_cols":18,"rows_kept":1004,"cut":false,"hidden":false,"merged":[]}
["Clear Description?","Comments","Correct 3-Digit NIGP?","Comments","PO Number","Status","PO Type","PO Date","Vendor ID","Vendor Name","Buyer","PO Line","PO Line Amount","PO Line Description","Five-Digit NIGP","Five-Digit NIGP Description","Three-Digit NIGP Description","PO Reference"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Stop"]

{"sheet":"Buyer Pivot","index":5,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,"Row Labels"]
[null,null,"(blank)"]
[null,null,"Grand Total"]

{"sheet":"Lookups","index":6,"n_rows":112,"n_cols":10,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
["<Select Entity Name from List>","Entity_Code","Entity_Fin_Sys",null,null,null,0.95,"Tier I (+)","Excellent","Tier I (+): A State Entity’s performance in this category reflects strong compliance with all applicable laws and administrative rules.  No significant weaknesses were identified.  Staff appears to be well-trained and are following both State and internal policies and procedures.  Any violations are minor and are easily corrected.  Risk of financial loss and/or accusations of improper procurement practices is very minimal and is not a concern at this time."]
["Abraham Baldwin Agricultural College (55700)",55700,"BOR PeopleSoft",null,null,null,0.85,"Tier I","Acceptable","Tier I: A State Entity’s performance in this category reflects compliance within acceptable parameters.  Adherence to training and policies appears to be adequate.  Any violations of laws and administrative rules are minor and are easily correctable.  Additional coaching for buyers indicated on the solicitations or purchase orders is recommended.  Risk of financial loss and/or accusations of improper procurement practices is minimal and should not be a concern at this time.  However, additional training will reduce the risk."]
["Administrative Services, Department of (40300)",40300,"TGM",null,null,null,0.75,"Tier II","Marginal","Tier II: A State Entity’s performance is less than satisfactory and indicates some lack of compliance with established laws and/or administrative rules that govern the purchase order and solicitation processes.  Increased attention is needed to training and auditing the work of the individual buyers.  Risk of financial loss and/or accusations of improper procurement practices exists but is minimal depending on the actual procurement area."]
["Agriculture, Department of (40200)",40200,"TGM",null,null,null,0.6,"Tier III","Underperforming","Tier III: A State Entity’s performance shows significant non-compliance in the procurement area receiving this rating.  Procurement personnel demonstrate a significant need for additional training and require close supervision in order to complete procurements according to Georgia law and administrative rules.  The State Entity is at a moderate risk of financial loss and/or accusations of improper procurement practices.  Issues need timely attention in order to implement corrective measures."]
["Albany State University (52100)",52100,"BOR PeopleSoft",null,null,null,null,"Tier IV","Unsatisfactory","Tier IV: A State Entity’s procurement personnel require strong supervisory attention and monitoring of purchase orders and solicitations.  Activities demonstrate either lack of adequate training or disregard for State procurement laws and administrative rules.  This places the State Entity at significant risk of financial loss and/or accusations of improper procurement practices.   Issues need immediate attention in order to implement corrective measures."]
["Albany Technical College (82000)",82000,"TGM"]
["Armstrong State University (52400)",52400,"BOR PeopleSoft"]
["Atlanta Metropolitan State College (61000)","61000","BOR PeopleSoft"]
["Athens Technical College (82200)",82200,"TGM"]
["Atlanta Technical College (82300)",82300,"TGM"]
["Audits and Accounts, Department of (40400)",40400,"TGM"]
["Augusta Technical College (82400)",82400,"TGM"]
["Augusta University (51200)",51200,"BOR PeopleSoft"]
["Bainbridge College (56200)",56200,"BOR PeopleSoft"]
["Banking and Finance, Department of (40600)",40600,"TGM"]
["Behavioral Health, Department of (44100)",44100,"TGM"]
["Board of Regents (47200)",47200,"BOR PeopleSoft"]
["Central Georgia Technical College (83500)",83500,"TGM"]
["Chattahoochee Technical College (82700)",82700,"TGM"]
["Clayton State University (52800)",52800,"BOR PeopleSoft"]
["Coastal Pines Technical College (81800)",81800,"TGM"]
["College of Coastal Georgia (56300)",56300,"BOR PeopleSoft"]
["Columbus State University (53000)",53000,"BOR PeopleSoft"]
["Columbus Technical College (82800)",82800,"TGM"]
["Community Affairs, Department of (42800)",42800,"TGM"]
["Community Health, Department of (41900)",41900,"TGM"]
["Community Supervision, Department of (47700)",47700,"TGM"]
["Corrections, Department of (46700)",46700,"TGM"]
["Criminal Justice Coordinating Council (42246)",42246,"SAO PeopleSoft"]
["Dalton State College (56900)",56900,"BOR PeopleSoft"]
["Darton College (57000)",57000,"BOR PeopleSoft"]
["Department of Early Care and Learning (46900)",46900,"TGM"]
["Drivers Services, Department of (47500)",47500,"TGM"]
["East Georgia State College (57200)",57200,"BOR PeopleSoft"]
["Economic Development, Department of (42900)",42900,"TGM"]
["Education, Department of (41400)",41400,"TGM"]
["Fort Valley State University (53300)",53300,"BOR PeopleSoft"]
["Georgia Bureau of Investigation (47100)",47100,"TGM"]
["Georgia College and State University (53600)",53600,"BOR PeopleSoft"]
["Georgia Forestry Commission (42000)",42000,"TGM"]
["Georgia Gwinnett College (54000)",54000,"BOR PeopleSoft"]
["Georgia Highlands College (57300)",57300,"BOR PeopleSoft"]
["Georgia Institute of Technology (50300)",50300,"BOR PeopleSoft"]
["Georgia Northwestern Technical College (83800)","82900","TGM"]
["Georgia Perimeter College (57100)",57100,"BOR PeopleSoft"]
["Georgia Piedmont Technical College (83000)",83000,"TGM"]
["Georgia Post Council - Tucker (46602)",46602,"SAO PeopleSoft"]
["Georgia Public Telecommunications Commission (97700)",97700,"SAO PeopleSoft"]
["Georgia Southern University (53900)",53900,"BOR PeopleSoft"]
["Georgia Southwestern State University (54200)",54200,"BOR PeopleSoft"]
["Georgia State University (50900)",50900,"BOR PeopleSoft"]
["Georgia Vocational Rehabilitation Agency","42700","TGM"]
["Gordon College (57600)",57600,"BOR PeopleSoft"]
["Governor's Office of Highway Safety (46627)",46627,"TGM"]
["Gwinnett Technical College (83200)",83200,"TGM"]
["Human Services, Department of (42700)",42700,"TGM"]
["Insurance, Department of (40800)",40800,"TGM"]
["Juvenile Justice, Department of (46100)",46100,"SAO PeopleSoft"]
["Kennesaw State University (54300)",54300,"BOR PeopleSoft"]
["Labor, Department of (44000)",44000,"TGM"]
["Lanier Technical College (83400)",83400,"TGM"]
["Law, Department of (44200)",44200,"TGM"]
["Middle Georgia State University (58400)",58400,"BOR PeopleSoft"]
["Natural Resources, Department of (46200)",46200,"TGM"]
["North Georgia Technical College (83800)",83800,"TGM"]
["Oconee Fall Line Technical College (81700)","81700","TGM"]
["Office of Planning and Budget (42200)",42200,"TGM"]
["Ogeechee Technical College (84400)",84400,"TGM"]
["Pardons and Paroles, State Board of (46500)",46500,"TGM"]
["Public Health, Department of (40500)",40500,"TGM"]
["Public Safety Training Center (46601)",46601,"TGM"]
["Public Safety, Department of (46600)",46600,"TGM"]
["Public Service Commission (47000)",47000,"Hybrid"]
["REGION 001 - DFCS","42700","SAO PeopleSoft"]
["REGION 002 - DFCS","42700","SAO PeopleSoft"]
["REGION 003 - DFCS","42700","SAO PeopleSoft"]
["REGION 004 - DFCS","42700","SAO PeopleSoft"]
["REGION 005 - DFCS","42700","SAO PeopleSoft"]
["REGION 006 - DFCS","42700","SAO PeopleSoft"]
["REGION 007 - DFCS","42700","SAO PeopleSoft"]
["REGION 008 - DFCS","42700","SAO PeopleSoft"]
["REGION 009 - DFCS","42700","SAO PeopleSoft"]
["REGION 010 - DFCS","42700","SAO PeopleSoft"]
["REGION 011 - DFCS","42700","SAO PeopleSoft"]
["REGION 012 - DFCS","42700","SAO PeopleSoft"]
["REGION 013 - DFCS","42700","SAO PeopleSoft"]
["REGION 014 - DFCS","42700","SAO PeopleSoft"]
["REGION 015 - DFCS","42700","SAO PeopleSoft"]
["REGION 016 - DFCS","42700","SAO PeopleSoft"]
["REGION 017 - DFCS","42700","SAO PeopleSoft"]
["Revenue, Department of (47400)",47400,"TGM"]
["Savannah State University (54800)",54800,"BOR PeopleSoft"]
["Savannah Technical College (84100)",84100,"TGM"]
["Secretary of State (47800)",47800,"TGM"]
["Soil and Water Conservation Commission, State (48000)",48000,"TGM"]
["South Georgia State College (58800)",58800,"BOR PeopleSoft"]
["South Georgia Technical College (84200)",84200,"TGM"]
["Southeastern Technical College (84300)",84300,"TGM"]
["Southern Crescent Technical College (83100)",83100,"TGM"]
["Southern Polytechnic State University (55000)",55000,"BOR PeopleSoft"]
["Southern Regional Technical College (83700)",83700,"TGM"]
["State Accounting Office (40700)",40700,"TGM"]
["Technical College System of Georgia (41500)",41500,"TGM"]
["Transportation, Department of (48400)",48400,"TGM"]
["University of Georgia (51800)",51800,"BOR PeopleSoft"]
["University of North Georgia (54500)",54500,"BOR PeopleSoft"]
["University of West Georgia (55400)",55400,"BOR PeopleSoft"]
["Valdosta State University (55100)",55100,"BOR PeopleSoft"]
["Veterans Services, Department of (48800)","48800","TGM"]
["West Georgia Technical College (82600)",82600,"TGM"]
["Wiregrass Technical College (84800)",84800,"TGM"]
["State Operations, Department of (00000)","00000","TGM"]